SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 35839: Reclassification might cause user permission issues and optimization failures

DetailsHotfixAboutRate It

Following reclassification in SAS® Markdown Optimization, SAS® High-Performance Markdown Optimization, SAS® Regular Price Optimization, or SAS® Promotion Optimization, the database table that controls user application component access is not correctly updated. If reclassification affects the ancestry of a user's root product or geography hierarchy access node, the access permission issues might result.

There are no error, warning, or note messages to indicate that a problem has occurred, but incorrect markdown calculations or fields might be displayed in the UI.

To circumvent this issue, you must manually remove authorizations (via the SAS® Merchandise Intelligence Plug-ins for SAS Management Console) at all lower hierarchy levels (i.e. authorize only at the highest hierarchy level) when read authorization occurs at multiple levels within a hierarchy after reclassification.

For example, if you had read authorization for a specific child at hierarchy level 7 and it is moved during reclass to a different level 6 parent for which you also have read authorization, then the application component access tables become incorrect. You cannot be given access at level 7, if you also have access at level 6.

NOTE: In SAS® High-Performance Markdown Optimization 4.3, this issue might manifest itself during optimization. Plans might fail to optimize and an error similar to the following is generated in your TKMI grid server log:

00:37:36 dimlq_2401161 : Error: dim load queue 'dimlq_2401161' encountered a fatal error

NOTE: The Hot Fix associated with this SAS Note ONLY fixes the issue that causes optimization to fail in SAS® High Performance Markdown Optimization 4.3.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Regular Price OptimizationMicrosoft Windows 2000 Advanced Server3.29.1 TS1M3 SP4
Microsoft Windows 2000 Datacenter Server3.29.1 TS1M3 SP4
Microsoft Windows 2000 Server3.29.1 TS1M3 SP4
Microsoft Windows 2000 Professional3.29.1 TS1M3 SP4
Microsoft Windows Server 2003 for x644.25.29.2 TS2M29.3 TS1M0
Microsoft Windows Server 2003 Datacenter Edition4.25.29.2 TS2M39.3 TS1M0
Microsoft Windows Server 2003 Standard Edition4.25.29.2 TS2M39.3 TS1M0
64-bit Enabled AIX4.25.29.2 TS2M39.3 TS1M0
Microsoft Windows Server 2003 Enterprise Edition4.25.29.2 TS2M39.3 TS1M0
Microsoft Windows Server 20084.25.29.2 TS2M39.3 TS1M0
Microsoft Windows Server 2008 for x644.25.29.2 TS2M39.3 TS1M0
SAS SystemSAS High-Performance Markdown OptimizationLinux for x644.35.29.2 TS2M39.3 TS1M0
SAS SystemSAS Promotion OptimizationMicrosoft Windows Server 2003 for x644.25.29.2 TS2M39.3 TS1M0
Microsoft Windows Server 20084.25.29.2 TS2M39.3 TS1M0
Microsoft Windows Server 2008 for x644.25.29.2 TS2M39.3 TS1M0
64-bit Enabled AIX4.25.29.2 TS2M39.3 TS1M0
Microsoft Windows Server 2003 Datacenter Edition4.25.29.2 TS2M39.3 TS1M0
Microsoft Windows Server 2003 Enterprise Edition4.25.29.2 TS2M39.3 TS1M0
Microsoft Windows Server 2003 Standard Edition4.25.29.2 TS2M39.3 TS1M0
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.